Skip Headers

Oracle® Transparent Gateway for Teradata Administrator's Guide 10g Release 2 (10.2) for HP-UX Part Number B14276-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# A Data Type Conversion

This appendix contains the following section:

- Data Type Conversion

## A.1 Data Type Conversion

The gateway converts Teradata data types to Oracle data types as follows:

Table A-1 Data Type Conversions

Teradata | Oracle | Comment
--- | --- | ---
BYTE | RAW | -
BYTEINT | NUMBER(3) | -
CHAR | CHAR | -
CHARACTER | CHAR | -
DATE | CHAR(10) or DATE | The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
DEC | NUMBER(p[,s]) | -
DECIMAL | NUMBER(p[,s]) | -
DOUBLE PRECISION | FLOAT(49) | -
FLOAT | FLOAT(49) | -
INT | NUMBER(10) | NUMBER range is -2,147,483,647 to 2,147,483,647
INTEGER | NUMBER(10) | NUMBER range is -2,147,483,647 to 2,147,483,647
INTERVAL | Not supported | -
LONG VARCHAR | LONG | -
NUMERIC | NUMBER(p[,s]) | -
REAL | FLOAT(49) | -
SMALLINT | NUMBER(5) | -
TIME | CHAR(8) or DATE | The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
TIMESTAMP | CHAR(23) or DATE | The conversion depends on the DateTimeFormat parameter in the ODBC DSN. Please refer to NCR's ODBC documentation
VARBYTE | RAW | VARBYTE is right padded. If the size is greater than 2000 it is truncated to RAW(2000)
VARCHAR | VARCHAR2 | If the size is greater than 4000 it is truncated to VARCHAR2(4000)